Prerequisites
Before designing a task with HP NonStop SQL/MP as an ODBC Target, the following prerequisites must be met:
- All source tables and their indexes must already exist on the target database.
-
The default name for the Replicate Apply Exceptions table (
attrep_apply_exceptions
) is not compliant with HP NonStop SQL/MP table naming conventions which dictate that table names cannot exceed 8 characters or contain non-alphanumeric characters. To resolve this conflict, you need to add the following entry to your NAVMAP file or create a new NAVMAP file (The NAVMAP file is located in the subvolume where ARC is installed):Syntax:
[SQLMP]
attrep_apply_exceptions= \machine_name.$volume_name.subvolume_name.atreapex
You also need to manually create the Apply Exceptions table on the HP NonStop SQL/MP target before starting the task. The table should be named
atreapex
and should contain the following columns:Column name data types Column name Data type TASK_NAME
Varchar(128)
TABLE_OWNER
Varchar(128)
TABLE_NAME
Varchar(128)
ERRORTIME
Datetime year to fraction
STATEMENT
Varchar(1000)
ERROR
Varchar(1000)
-
If you intend to enable the Replicate Store Changes option, you need to manually create the audit table on the HP NonStop SQL/MP target before starting the task.
Information noteThis also requires you make the following changes in the Store Changes Settings tab:
-
Select Audit table from the Store changes drop-down list.
- Change the default audit table name from
attrep_audit_table
toatreauta
.
Create a table named
atreauta
with the following parameters:Parameter data types Column Name Data Type *task_name
Varchar(110)
*stream_position
Varchar(128)
change_seq
Varchar(35)
change_oper
Varchar(1)
schema_name
Varchar(128)
table_name
Varchar(128)
operation
Varchar(12)
transaction_id
Varchar(32)
timestamp
Timestamp
change_record
Varchar(1000)
bu_change_record
Varchar(1000)
Information note: You also need to create a Unique Index consisting of the task_name and stream_position columns (marked with an asterisk above).
-